185. Department Top Three Salaries.sql

WITH cte AS(
SELECTd.nameAS Department,e.nameAS Employee,e.salaryAS Salary,
 DENSE_RANK() OVER w rnk
FROM employee_185 e
JOIN department_185 d ONe.department_id=d.id
WINDOW w AS (PARTITION BY d.nameORDER BYe.salaryDESC)
)

SELECT Department,Employee,Salary,rnk
FROM cte 
WHERE rnk BETWEEN 1AND3;